package com.example.workoutjournal;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class MySQLiteHelper extends SQLiteOpenHelper {

  public static final String TABLE_SETS = "sets";
  public static final String TABLE_EXERCISES = "exercises";
  public static final String COLUMN_ID = "_id";
  public static final String COLUMN_EXERCISENAME = "exercisename";
  public static final String COLUMN_REPETITIONS = "repetitions";
  public static final String COLUMN_WEIGHT = "weight";
  public static final String COLUMN_SERIES = "series";
  public static final String COLUMN_SETNAME = "setname";
  public static final String COLUMN_SETID = "setid";

  private static final String DATABASE_NAME = "commments.db";
  private static final int DATABASE_VERSION = 1;

  // Database creation sql statement
  private static final String DATABASE_CREATE_SETS = "create table "
      + TABLE_SETS + "(" + COLUMN_ID
      + " integer primary key autoincrement, " + COLUMN_SETNAME
      + " text not null);";
  
  private static final String DATABASE_CREATE_EXERCISES = "create table "
	      + TABLE_EXERCISES + "(" + COLUMN_ID
	      + " integer primary key autoincrement, " + COLUMN_SETID +" integer,"+ COLUMN_EXERCISENAME
	      + " text not null, "+COLUMN_REPETITIONS+" integer, "+COLUMN_SERIES+" integer, "+COLUMN_WEIGHT+" integer);";

  public MySQLiteHelper(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase database) {
    database.execSQL(DATABASE_CREATE_SETS);
    database.execSQL(DATABASE_CREATE_EXERCISES);
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    Log.w(MySQLiteHelper.class.getName(),
        "Upgrading database from version " + oldVersion + " to "
            + newVersion + ", which will destroy all old data");
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_SETS);
    onCreate(db);
  }

} 